<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
    <title>Home Page</title>
    <link href="Styles/style.css" rel="stylesheet" type="text/css" />

</head>
<body>     

<h2 class="title-list">Search Products </h2>                 

<form name="form1" method="get" action="advancesearch_action.php">
<table width="200" border="0">
  <tr>
    <td>Name</td>
    <td>
        <input type="text" name="txtname" id="txtname" />    </td>
  </tr>
  <tr>
    <td>Price from</td>
    <td><input type="text" name="txtpricefrom" id="txtpricefrom" /></td>
  </tr>
  <tr>
    <td>Price to</td>
    <td><input type="text" name="txtpriceto" id="txtpriceto" /></td>
  </tr>
  <tr>
  
    <td>Manufacturer</td>
    <td>
    <select name="manu" >
    	<option id="all" value="all">--All--</option>
	<?php
		$query = "select * from hangsanxuat";
		$result = DataProvider::ExecuteQuery($query);
		while($row = mysql_fetch_array($result))
		{	
 	?>
    	<option id="<?php echo $row['MaHangSanXuat']; ?>" value="<?php echo $row['MaHangSanXuat']; ?>"><?php echo $row['TenHangSanXuat']; ?></option>
	<?php
		}
	?>        
    </select>
    </td>
  </tr>
  <tr>
    <td>Category</td>
    <td>
    <select name="cat">
    <option id="all" value="all">--All--</option>
	<?php
		$query = "select * from loaisanpham";
		$result = DataProvider::ExecuteQuery($query);
		while($row1 = mysql_fetch_array($result))
		{	
 	?>    
    	<option id="<?php echo $row1['MaLoaiSanPham']; ?>" value="<?php echo $row1['MaLoaiSanPham']; ?>"><?php echo $row1['TenLoaiSanPham']; ?></option>
	<?php
		}
	?>        
    </select>
    </td>
  </tr>
  <tr>
            <td>
            </td>
            <td>
                <span class="error-message" id="labelBaoLoi" ></span>
            </td>
        </tr>
  <tr>
  	<td colspan="2"><label>
  	  <input type="submit" name="btnsearch" id="btnsearch" value="Search">
      &nbsp;
       <input type="reset" name="clear" id="clear" value="Clear">
  	</label></td>
  </tr>
</table>
</form> 

</body>
</html>














